﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="MyRecipeBook_DataSet" targetNamespace="http://tempuri.org/MyRecipeBook_DataSet.xsd" xmlns:mstns="http://tempuri.org/MyRecipeBook_DataSet.xsd" xmlns="http://tempuri.org/MyRecipeBook_DataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="MyRecipeBook_DatabaseConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="MyRecipeBook_DatabaseConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.MyRecipeBook.V2.ClassLib.Properties.Settings.GlobalReference.Default.MyRecipeBook_DatabaseConnectionString" Provider="Microsoft.SqlServerCe.Client.3.5" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CourseDefinitionTableAdapter" GeneratorDataComponentClassName="CourseDefinitionTableAdapter" Name="CourseDefinition" UserDataComponentName="CourseDefinitionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MyRecipeBook_DatabaseConnectionString (Settings)" DbObjectName="CourseDefinition" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [CourseDefinition] WHERE (([Id] = @p1) AND ((@p2 = 1 AND [Name] IS NULL) OR ([Name] = @p3)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [CourseDefinition] ([Name]) VALUES (@p1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT [Id], [Name] FROM [CourseDefinition]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       CourseDefinition
SET                Name = @p1
WHERE        (Id = @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="p1" ColumnName="Name" DataSourceName="CourseDefinition" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="p2" ColumnName="Id" DataSourceName="CourseDefinition" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="MyRecipeBook_DatabaseConnectionString (Settings)" DbObjectName="CourseDefinition" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByName" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByName" GeneratorSourceName="FillByName" GetMethodModifier="Public" GetMethodName="GetDataByName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByName" UserSourceName="FillByName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Id, Name FROM CourseDefinition WHERE (Name = @name)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="name" ColumnName="Name" DataSourceName="CourseDefinition" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RecipeIngredientsTableAdapter" GeneratorDataComponentClassName="RecipeIngredientsTableAdapter" Name="RecipeIngredients" UserDataComponentName="RecipeIngredientsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MyRecipeBook_DatabaseConnectionString (Settings)" DbObjectName="RecipeIngredients" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [RecipeIngredients] WHERE (([Id] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [RecipeIngredients] ([Recipe_Id], [Ingredient_Id], [RecipeIngredientMeasurement_Id], [Order]) VALUES (@p1, @p2, @p3, @p4)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Recipe_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ingredient_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RecipeIngredientMeasurement_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [Id], [Recipe_Id], [Ingredient_Id], [RecipeIngredientMeasurement_Id], [Order] FROM [RecipeIngredients]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [RecipeIngredients] SET [Recipe_Id] = @p1, [Ingredient_Id] = @p2, [RecipeIngredientMeasurement_Id] = @p3, [Order] = @p4 WHERE (([Id] = @p5))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Recipe_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ingredient_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RecipeIngredientMeasurement_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="Order" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Recipe_Id" DataSetColumn="Recipe_Id" />
              <Mapping SourceColumn="Ingredient_Id" DataSetColumn="Ingredient_Id" />
              <Mapping SourceColumn="RecipeIngredientMeasurement_Id" DataSetColumn="RecipeIngredientMeasurement_Id" />
              <Mapping SourceColumn="Order" DataSetColumn="Order" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CuisineDefinitionTableAdapter" GeneratorDataComponentClassName="CuisineDefinitionTableAdapter" Name="CuisineDefinition" UserDataComponentName="CuisineDefinitionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MyRecipeBook_DatabaseConnectionString (Settings)" DbObjectName="CuisineDefinition" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [CuisineDefinition] WHERE (([Id] = @p1) AND ((@p2 = 1 AND [Name] IS NULL) OR ([Name] = @p3)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [CuisineDefinition] ([Name]) VALUES (@p1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [Id], [Name] FROM [CuisineDefinition]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       CuisineDefinition
SET                Name = @p1
WHERE        (Id = @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="p1" ColumnName="Name" DataSourceName="CuisineDefinition" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="p2" ColumnName="Id" DataSourceName="CuisineDefinition" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="MyRecipeBook_DatabaseConnectionString (Settings)" DbObjectName="CuisineDefinition" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByName" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByName" GeneratorSourceName="FillByName" GetMethodModifier="Public" GetMethodName="GetDataByName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByName" UserSourceName="FillByName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT [Id], [Name] FROM [CuisineDefinition] WHERE ([Name] = @name)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="name" ColumnName="Name" DataSourceName="CuisineDefinition" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="IngredientDefinitionTableAdapter" GeneratorDataComponentClassName="IngredientDefinitionTableAdapter" Name="IngredientDefinition" UserDataComponentName="IngredientDefinitionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MyRecipeBook_DatabaseConnectionString (Settings)" DbObjectName="IngredientDefinition" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [IngredientDefinition] WHERE (([Id] = @p1) AND ((@p2 = 1 AND [Name] IS NULL) OR ([Name] = @p3)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [IngredientDefinition] ([Name]) VALUES (@p1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [Id], [Name] FROM [IngredientDefinition]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [IngredientDefinition] SET [Name] = @p1 WHERE (([Id] = @p2) AND ((@p3 = 1 AND [Name] IS NULL) OR ([Name] = @p4)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MeasurementDefinitionTableAdapter" GeneratorDataComponentClassName="MeasurementDefinitionTableAdapter" Name="MeasurementDefinition" UserDataComponentName="MeasurementDefinitionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MyRecipeBook_DatabaseConnectionString (Settings)" DbObjectName="MeasurementDefinition" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [MeasurementDefinition] WHERE (([Id] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [MeasurementDefinition] ([Name], [Type]) VALUES (@p1, @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [Id], [Name], [Type] FROM [MeasurementDefinition]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       MeasurementDefinition
SET                Name = @p1, Type = @p2
WHERE        (Id = @p3)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="p1" ColumnName="Name" DataSourceName="MeasurementDefinition" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="p2" ColumnName="Type" DataSourceName="MeasurementDefinition" DataTypeServer="nchar(1)" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NChar" Scale="0" Size="1" SourceColumn="Type" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="p3" ColumnName="Id" DataSourceName="MeasurementDefinition" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="MyRecipeBook_DatabaseConnectionString (Settings)" DbObjectName="MeasurementDefinition" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByName" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByName" GeneratorSourceName="FillByName" GetMethodModifier="Public" GetMethodName="GetDataByName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByName" UserSourceName="FillByName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT [Id], [Name], [Type] FROM [MeasurementDefinition] WHERE ([name] = @name)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="name" ColumnName="Name" DataSourceName="MeasurementDefinition" DataTypeServer="nvarchar(100)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RecipeDefinitionTableAdapter" GeneratorDataComponentClassName="RecipeDefinitionTableAdapter" Name="RecipeDefinition" UserDataComponentName="RecipeDefinitionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MyRecipeBook_DatabaseConnectionString (Settings)" DbObjectName="RecipeDefinition" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [RecipeDefinition] WHERE (([Id] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [RecipeDefinition] ([Name], [Cuisine_Id], [Course_Id]) VALUES (@p1, @p2, @p3)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cuisine_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Course_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [Id], [Name], [Cuisine_Id], [Course_Id] FROM [RecipeDefinition]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [RecipeDefinition] SET [Name] = @p1, [Cuisine_Id] = @p2, [Course_Id] = @p3 WHERE (([Id] = @p4))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Cuisine_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Course_Id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Cuisine_Id" DataSetColumn="Cuisine_Id" />
              <Mapping SourceColumn="Course_Id" DataSetColumn="Course_Id" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RecipeIngredientMeasurementTableAdapter" GeneratorDataComponentClassName="RecipeIngredientMeasurementTableAdapter" Name="RecipeIngredientMeasurement" UserDataComponentName="RecipeIngredientMeasurementTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MyRecipeBook_DatabaseConnectionString (Settings)" DbObjectName="RecipeIngredientMeasurement" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [RecipeIngredientMeasurement] WHERE (([Id] = @p1))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [RecipeIngredientMeasurement] ([Measurement_Id_1], [Measurement_Amount_1], [Measurement_Id_2], [Measurement_Amount_2]) VALUES (@p1, @p2, @p3, @p4)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Measurement_Id_1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Measurement_Amount_1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Measurement_Id_2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Measurement_Amount_2" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [Id], [Measurement_Id_1], [Measurement_Amount_1], [Measurement_Id_2], [Measurement_Amount_2] FROM [RecipeIngredientMeasurement]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [RecipeIngredientMeasurement] SET [Measurement_Id_1] = @p1, [Measurement_Amount_1] = @p2, [Measurement_Id_2] = @p3, [Measurement_Amount_2] = @p4 WHERE (([Id] = @p5))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Measurement_Id_1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Measurement_Amount_1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Measurement_Id_2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Measurement_Amount_2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p5" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Measurement_Id_1" DataSetColumn="Measurement_Id_1" />
              <Mapping SourceColumn="Measurement_Amount_1" DataSetColumn="Measurement_Amount_1" />
              <Mapping SourceColumn="Measurement_Id_2" DataSetColumn="Measurement_Id_2" />
              <Mapping SourceColumn="Measurement_Amount_2" DataSetColumn="Measurement_Amount_2" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="MealDefinitionTableAdapter" GeneratorDataComponentClassName="MealDefinitionTableAdapter" Name="MealDefinition" UserDataComponentName="MealDefinitionTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="MyRecipeBook_DatabaseConnectionString (Settings)" DbObjectName="MealDefinition" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [MealDefinition] WHERE (([Id] = @p1) AND ([Name] = @p2))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [MealDefinition] ([Name]) VALUES (@p1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT [Id], [Name] FROM [MealDefinition]</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>UPDATE       MealDefinition
SET                Name = @p1
WHERE        (Id = @p2)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="p1" ColumnName="Name" DataSourceName="MealDefinition" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@p1" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="p2" ColumnName="Id" DataSourceName="MealDefinition" DataTypeServer="int(4)" DbType="Int32" Direction="Input" ParameterName="@p2" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="MyRecipeBook_DatabaseConnectionString (Settings)" DbObjectName="MealDefinition" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByName" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByName" GeneratorSourceName="FillByName" GetMethodModifier="Public" GetMethodName="GetDataByName" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByName" UserSourceName="FillByName">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT [Id], [Name] FROM [MealDefinition] WHERE ([name] = @name)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="name" ColumnName="Name" DataSourceName="MealDefinition" DataTypeServer="nvarchar(50)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="MyRecipeBook_DataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="MyRecipeBook_DataSet" msprop:Generator_DataSetName="MyRecipeBook_DataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="CourseDefinition" msprop:Generator_UserTableName="CourseDefinition" msprop:Generator_RowDeletedName="CourseDefinitionRowDeleted" msprop:Generator_RowChangedName="CourseDefinitionRowChanged" msprop:Generator_RowClassName="CourseDefinitionRow" msprop:Generator_RowChangingName="CourseDefinitionRowChanging" msprop:Generator_RowEvArgName="CourseDefinitionRowChangeEvent" msprop:Generator_RowEvHandlerName="CourseDefinitionRowChangeEventHandler" msprop:Generator_TableClassName="CourseDefinitionDataTable" msprop:Generator_TableVarName="tableCourseDefinition" msprop:Generator_RowDeletingName="CourseDefinitionRowDeleting" msprop:Generator_TablePropName="CourseDefinition">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="RecipeIngredients" msprop:Generator_UserTableName="RecipeIngredients" msprop:Generator_RowDeletedName="RecipeIngredientsRowDeleted" msprop:Generator_RowChangedName="RecipeIngredientsRowChanged" msprop:Generator_RowClassName="RecipeIngredientsRow" msprop:Generator_RowChangingName="RecipeIngredientsRowChanging" msprop:Generator_RowEvArgName="RecipeIngredientsRowChangeEvent" msprop:Generator_RowEvHandlerName="RecipeIngredientsRowChangeEventHandler" msprop:Generator_TableClassName="RecipeIngredientsDataTable" msprop:Generator_TableVarName="tableRecipeIngredients" msprop:Generator_RowDeletingName="RecipeIngredientsRowDeleting" msprop:Generator_TablePropName="RecipeIngredients">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Recipe_Id" msprop:Generator_UserColumnName="Recipe_Id" msprop:Generator_ColumnVarNameInTable="columnRecipe_Id" msprop:Generator_ColumnPropNameInRow="Recipe_Id" msprop:Generator_ColumnPropNameInTable="Recipe_IdColumn" type="xs:int" />
              <xs:element name="Ingredient_Id" msprop:Generator_UserColumnName="Ingredient_Id" msprop:Generator_ColumnVarNameInTable="columnIngredient_Id" msprop:Generator_ColumnPropNameInRow="Ingredient_Id" msprop:Generator_ColumnPropNameInTable="Ingredient_IdColumn" type="xs:int" />
              <xs:element name="RecipeIngredientMeasurement_Id" msprop:Generator_UserColumnName="RecipeIngredientMeasurement_Id" msprop:Generator_ColumnVarNameInTable="columnRecipeIngredientMeasurement_Id" msprop:Generator_ColumnPropNameInRow="RecipeIngredientMeasurement_Id" msprop:Generator_ColumnPropNameInTable="RecipeIngredientMeasurement_IdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Order" msprop:Generator_UserColumnName="Order" msprop:Generator_ColumnVarNameInTable="columnOrder" msprop:Generator_ColumnPropNameInRow="Order" msprop:Generator_ColumnPropNameInTable="OrderColumn" type="xs:short" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CuisineDefinition" msprop:Generator_UserTableName="CuisineDefinition" msprop:Generator_RowDeletedName="CuisineDefinitionRowDeleted" msprop:Generator_RowChangedName="CuisineDefinitionRowChanged" msprop:Generator_RowClassName="CuisineDefinitionRow" msprop:Generator_RowChangingName="CuisineDefinitionRowChanging" msprop:Generator_RowEvArgName="CuisineDefinitionRowChangeEvent" msprop:Generator_RowEvHandlerName="CuisineDefinitionRowChangeEventHandler" msprop:Generator_TableClassName="CuisineDefinitionDataTable" msprop:Generator_TableVarName="tableCuisineDefinition" msprop:Generator_RowDeletingName="CuisineDefinitionRowDeleting" msprop:Generator_TablePropName="CuisineDefinition">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="IngredientDefinition" msprop:Generator_UserTableName="IngredientDefinition" msprop:Generator_RowDeletedName="IngredientDefinitionRowDeleted" msprop:Generator_RowChangedName="IngredientDefinitionRowChanged" msprop:Generator_RowClassName="IngredientDefinitionRow" msprop:Generator_RowChangingName="IngredientDefinitionRowChanging" msprop:Generator_RowEvArgName="IngredientDefinitionRowChangeEvent" msprop:Generator_RowEvHandlerName="IngredientDefinitionRowChangeEventHandler" msprop:Generator_TableClassName="IngredientDefinitionDataTable" msprop:Generator_TableVarName="tableIngredientDefinition" msprop:Generator_RowDeletingName="IngredientDefinitionRowDeleting" msprop:Generator_TablePropName="IngredientDefinition">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MeasurementDefinition" msprop:Generator_UserTableName="MeasurementDefinition" msprop:Generator_RowDeletedName="MeasurementDefinitionRowDeleted" msprop:Generator_RowChangedName="MeasurementDefinitionRowChanged" msprop:Generator_RowClassName="MeasurementDefinitionRow" msprop:Generator_RowChangingName="MeasurementDefinitionRowChanging" msprop:Generator_RowEvArgName="MeasurementDefinitionRowChangeEvent" msprop:Generator_RowEvHandlerName="MeasurementDefinitionRowChangeEventHandler" msprop:Generator_TableClassName="MeasurementDefinitionDataTable" msprop:Generator_TableVarName="tableMeasurementDefinition" msprop:Generator_RowDeletingName="MeasurementDefinitionRowDeleting" msprop:Generator_TablePropName="MeasurementDefinition">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnPropNameInTable="TypeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="RecipeDefinition" msprop:Generator_UserTableName="RecipeDefinition" msprop:Generator_RowDeletedName="RecipeDefinitionRowDeleted" msprop:Generator_RowChangedName="RecipeDefinitionRowChanged" msprop:Generator_RowClassName="RecipeDefinitionRow" msprop:Generator_RowChangingName="RecipeDefinitionRowChanging" msprop:Generator_RowEvArgName="RecipeDefinitionRowChangeEvent" msprop:Generator_RowEvHandlerName="RecipeDefinitionRowChangeEventHandler" msprop:Generator_TableClassName="RecipeDefinitionDataTable" msprop:Generator_TableVarName="tableRecipeDefinition" msprop:Generator_RowDeletingName="RecipeDefinitionRowDeleting" msprop:Generator_TablePropName="RecipeDefinition">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Cuisine_Id" msprop:Generator_UserColumnName="Cuisine_Id" msprop:Generator_ColumnVarNameInTable="columnCuisine_Id" msprop:Generator_ColumnPropNameInRow="Cuisine_Id" msprop:Generator_ColumnPropNameInTable="Cuisine_IdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Course_Id" msprop:Generator_UserColumnName="Course_Id" msprop:Generator_ColumnVarNameInTable="columnCourse_Id" msprop:Generator_ColumnPropNameInRow="Course_Id" msprop:Generator_ColumnPropNameInTable="Course_IdColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="RecipeIngredientMeasurement" msprop:Generator_UserTableName="RecipeIngredientMeasurement" msprop:Generator_RowDeletedName="RecipeIngredientMeasurementRowDeleted" msprop:Generator_RowChangedName="RecipeIngredientMeasurementRowChanged" msprop:Generator_RowClassName="RecipeIngredientMeasurementRow" msprop:Generator_RowChangingName="RecipeIngredientMeasurementRowChanging" msprop:Generator_RowEvArgName="RecipeIngredientMeasurementRowChangeEvent" msprop:Generator_RowEvHandlerName="RecipeIngredientMeasurementRowChangeEventHandler" msprop:Generator_TableClassName="RecipeIngredientMeasurementDataTable" msprop:Generator_TableVarName="tableRecipeIngredientMeasurement" msprop:Generator_RowDeletingName="RecipeIngredientMeasurementRowDeleting" msprop:Generator_TablePropName="RecipeIngredientMeasurement">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Measurement_Id_1" msprop:Generator_UserColumnName="Measurement_Id_1" msprop:Generator_ColumnVarNameInTable="columnMeasurement_Id_1" msprop:Generator_ColumnPropNameInRow="Measurement_Id_1" msprop:Generator_ColumnPropNameInTable="Measurement_Id_1Column" type="xs:int" />
              <xs:element name="Measurement_Amount_1" msprop:Generator_UserColumnName="Measurement_Amount_1" msprop:Generator_ColumnVarNameInTable="columnMeasurement_Amount_1" msprop:Generator_ColumnPropNameInRow="Measurement_Amount_1" msprop:Generator_ColumnPropNameInTable="Measurement_Amount_1Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Measurement_Id_2" msprop:Generator_UserColumnName="Measurement_Id_2" msprop:Generator_ColumnVarNameInTable="columnMeasurement_Id_2" msprop:Generator_ColumnPropNameInRow="Measurement_Id_2" msprop:Generator_ColumnPropNameInTable="Measurement_Id_2Column" type="xs:int" minOccurs="0" />
              <xs:element name="Measurement_Amount_2" msprop:Generator_UserColumnName="Measurement_Amount_2" msprop:Generator_ColumnVarNameInTable="columnMeasurement_Amount_2" msprop:Generator_ColumnPropNameInRow="Measurement_Amount_2" msprop:Generator_ColumnPropNameInTable="Measurement_Amount_2Column" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="25" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="MealDefinition" msprop:Generator_UserTableName="MealDefinition" msprop:Generator_RowDeletedName="MealDefinitionRowDeleted" msprop:Generator_TableClassName="MealDefinitionDataTable" msprop:Generator_RowChangedName="MealDefinitionRowChanged" msprop:Generator_RowClassName="MealDefinitionRow" msprop:Generator_RowChangingName="MealDefinitionRowChanging" msprop:Generator_RowEvArgName="MealDefinitionRowChangeEvent" msprop:Generator_RowEvHandlerName="MealDefinitionRowChangeEventHandler" msprop:Generator_TablePropName="MealDefinition" msprop:Generator_TableVarName="tableMealDefinition" msprop:Generator_RowDeletingName="MealDefinitionRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1">
      <xs:selector xpath=".//mstns:CourseDefinition" />
      <xs:field xpath="mstns:Name" />
    </xs:unique>
    <xs:unique name="Constraint2" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CourseDefinition" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="RecipeIngredients_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:RecipeIngredients" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="CuisineDefinition_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:CuisineDefinition" />
      <xs:field xpath="mstns:Name" />
    </xs:unique>
    <xs:unique name="CuisineDefinition_Constraint2" msdata:ConstraintName="Constraint2" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CuisineDefinition" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="IngredientDefinition_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:IngredientDefinition" />
      <xs:field xpath="mstns:Name" />
    </xs:unique>
    <xs:unique name="IngredientDefinition_Constraint2" msdata:ConstraintName="Constraint2" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:IngredientDefinition" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="MeasurementDefinition_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MeasurementDefinition" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="RecipeDefinition_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:RecipeDefinition" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="RecipeIngredientMeasurement_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:RecipeIngredientMeasurement" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="MealDefinition_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:MealDefinition" />
      <xs:field xpath="mstns:Name" />
    </xs:unique>
    <xs:unique name="MealDefinition_Constraint2" msdata:ConstraintName="Constraint2" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:MealDefinition" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
  </xs:element>
</xs:schema>